package com.power.mapper;

import com.power.domain.Basket;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
* @author dingchunlin
* @description 针对表【basket(购物车)】的数据库操作Mapper
* @createDate 2024-07-10 15:12:13
* @Entity com.power.domain.Basket
*/
@Mapper
public interface BasketMapper extends BaseMapper<Basket> {

    @Select("select ifnull(sum(prod_count),0) from basket where open_id = #{openId}")
    Integer queryMemberBasketProdCount(String openId);

}




